Skip to main content

AnyDB Date & Time Cell

Date & Time Cell Type​

Date & Time cells are designed to store date and time values. AnyDB stores date & time values as a timestamp that is the number of seconds since the Unix epoch (January 1, 1970). This allows for easy manipulation and comparison of date & time values.

Date & Time Cell Options

Additional Options​

Date cells have the following additional options:

Date & Time Cell Options

  • Format: Set the format in which the date will be displayed. You can choose from various formats.
  • Absolute: Enable or disable the use of absolute dates. When enabled, the date will not be converted to local time when being displayed. This is useful for storing dates that should not be affected by time zone changes.
tip

Note: When you set a date value, that date is converted to a UTC timezone based date. When being displayed, it is converted to the local timezone of the browser for display.